package com.yx.changdao.common.data;


/**
 * @Description: <br />
 * excel版本枚举
 * <p>
 * <br />
 * @Auther: Zhangjiashun
 * @create 2019/11/20 8:50
 */
public enum ExcelVersion {

    /**
     * 虽然V2007版本支持最大支持1048575 * 16383 ，
     * V2003版支持65535*255
     * 如果使用如此庞大的对象集合会导致内存溢出，
     * 1000*100 全部导出预计时间为27s左右
     */
    V2003("xls", 65535, 255),
    V2007("xlsx", 1048575, 16383);

    private String suffix;

    private int maxRow;

    private int maxColumn;

    ExcelVersion(String suffix, int maxRow, int maxColumn) {
        this.suffix = suffix;
        this.maxRow = maxRow;
        this.maxColumn = maxColumn;
    }

    public String getSuffix() {
        return this.suffix;
    }

    public int getMaxRow() {
        return maxRow;
    }

    public void setMaxRow(int maxRow) {
        this.maxRow = maxRow;
    }

    public int getMaxColumn() {
        return maxColumn;
    }

    public void setMaxColumn(int maxColumn) {
        this.maxColumn = maxColumn;
    }

    public void setSuffix(String suffix) {
        this.suffix = suffix;
    }

}
